USE [ANTS_NetServer]
GO

/****** Object:  StoredProcedure [dbo].[proc_NVRDeviceInfo_selectByID]    Script Date: 04/21/2013 15:26:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create proc [dbo].[proc_NVRDeviceInfo_selectByID]
(
    @deviceSN nvarchar(50)
)
as 
select *from NVRDeviceInfo where deviceSN=@deviceSN
GO

